package nc.impl.cad.templettable;

public class RollCompTempletTable implements ITempTableInfo {

	public int getColumns() {
		return 7;
	}

	public String getDB2Columns() {
		return "PK_TASK VARCHAR(20),PK_COMPDISTR VARCHAR(20),PK_LOANTALLY VARCHAR(50),PK_CONTRACT VARCHAR(20),PK_DUEBILL VARCHAR(20),PK_LOSSCALSCRMODEL VARCHAR(20),OPDATE CHAR(10),TS CHAR(19)";
	}

	public String getDB2Indexs() {
		return "PK_DUEBILL";
	}

	public String getOracleColumns() {
		return "PK_TASK VARCHAR2(20),PK_COMPDISTR VARCHAR2(20),PK_LOANTALLY VARCHAR2(50),PK_CONTRACT VARCHAR2(20),PK_DUEBILL VARCHAR2(20),PK_LOSSCALSCRMODEL VARCHAR2(20),OPDATE CHAR(10),TS CHAR(19)";
	}

	public String getOracleIndexs() {
		return "PK_DUEBILL";
	}

	public String getTableName() {
		return "CAD_TMP_LOANTALLY";
	}

}
